{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#爬取起点中文网完本小说信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests,json,time,re\n",
    "from requests.exceptions import RequestException\n",
    "from pyquery import PyQuery as pq\n",
    "from fontTools.ttLib import TTFont\n",
    "from io import BytesIO\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "start_url = 'https://www.qidian.com/finish?action=hidden&orderId=3&vip=1&sign=1&style=2&pageSize=50&siteid=1&pubflag=0&hiddenField=2&page='"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_font(url):\n",
    "    response = requests.get(url)\n",
    "    font = TTFont(BytesIO(response.content))\n",
    "    cmap = font.getBestCmap()\n",
    "    font.close()\n",
    "    return cmap"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_encode(cmap,values):\n",
    "    WORD_MAP = {'zero':'0','one':'1','two':'2','three':'3','four':'4','five':'5','six':'6','seven':'7','eight':'8','nine':'9','period':'.'}\n",
    "    word_count=''\n",
    "    for value in values.split(';'):\n",
    "        value = value[2:]\n",
    "        key = cmap[int(value)]\n",
    "        word_count += WORD_MAP[key]\n",
    "    return word_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_index(start_url):\n",
    "    #获取当前页面的html\n",
    "    response = requests.get(start_url).text   \n",
    "    doc = pq(response)\n",
    "    #获取当前字体文件名称（point1）\n",
    "    classattr = doc('tr .total span').attr('class')\n",
    "    pattern = '</style><span.*?%s.*?>(.*?)</span>'%classattr\n",
    "    #获取当前页面所有被字数字符\n",
    "    numberlist = re.findall(pattern,response)\n",
    "    #获取当前包含字体文件链接的文本（point2）\n",
    "    fonturl = doc('tr .total style').text() \n",
    "    #通过正则获取当前页面字体文件链接\n",
    "    url = re.search('woff.*?url.*?\\'(.+?)\\'.*?truetype',fonturl) .group(1)\n",
    "    cmap = get_font(url)\n",
    "#     point3\n",
    "    books = doc('tbody > tr').items()\n",
    "    i = 0\n",
    "    df = pd.DataFrame()\n",
    "    for book in books:\n",
    "        item = {}\n",
    "        item['类别'] = book('.td-one').text()\n",
    "        item['小说名称'] = book('.name').text()\n",
    "        item['最新章节'] = book('.chapter').text()\n",
    "        item['字数'] = get_encode(cmap,numberlist[i][:-1])\n",
    "        item['作者'] = book('.author').text()        \n",
    "        item['更新时间'] = book('.date').text()\n",
    "        i += 1\n",
    "        df = df.append(item, ignore_index=True)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "for page in range(1,196):\n",
    "    url = start_url + str(page)\n",
    "    get_index(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>作者</th>\n",
       "      <th>字数</th>\n",
       "      <th>小说名称</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>最新章节</th>\n",
       "      <th>类别</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>雷云风暴</td>\n",
       "      <td>2019.35</td>\n",
       "      <td>从零开始</td>\n",
       "      <td>2016-03-21</td>\n",
       "      <td>第23卷 第六章放飞希望（完结篇）</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>小段探花</td>\n",
       "      <td>1588.76</td>\n",
       "      <td>修神外传</td>\n",
       "      <td>2016-10-09</td>\n",
       "      <td>探花新书《修神外传仙界篇》已经上传</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>汉宝</td>\n",
       "      <td>1261.26</td>\n",
       "      <td>移动藏经阁</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>番外，普林星系篇（2）</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>傅啸尘</td>\n",
       "      <td>1168.08</td>\n",
       "      <td>武神空间</td>\n",
       "      <td>2016-09-17</td>\n",
       "      <td>完本感言！读者请进！</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>傲月长空</td>\n",
       "      <td>1104.23</td>\n",
       "      <td>异世傲天</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>第1878~1882【大结局！】</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>卧牛真人</td>\n",
       "      <td>1040.22</td>\n",
       "      <td>修真四万年</td>\n",
       "      <td>2018-08-31</td>\n",
       "      <td>新书预告结束和开始</td>\n",
       "      <td>「科幻·未来世界」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>天雷猪</td>\n",
       "      <td>1011.16</td>\n",
       "      <td>剑神重生</td>\n",
       "      <td>2014-06-01</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>张扬的五月</td>\n",
       "      <td>994.86</td>\n",
       "      <td>网游之倒行逆施</td>\n",
       "      <td>2018-04-30</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>velver</td>\n",
       "      <td>988.68</td>\n",
       "      <td>左道旁门</td>\n",
       "      <td>2015-12-22</td>\n",
       "      <td>后记</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>幻雨</td>\n",
       "      <td>978.6</td>\n",
       "      <td>百炼成仙</td>\n",
       "      <td>2015-05-26</td>\n",
       "      <td>幻雨新书《厨道仙途》，大家请去看看哦！</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>韩错</td>\n",
       "      <td>916.92</td>\n",
       "      <td>恋战星梦</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>第二百章恋战星梦</td>\n",
       "      <td>「都市·娱乐明星」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>狼牙怪兽</td>\n",
       "      <td>902.23</td>\n",
       "      <td>枪魔霸世</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>《后记》</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>我叫排云掌</td>\n",
       "      <td>898.69</td>\n",
       "      <td>武侠世界大穿越</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>完本感言以及新书</td>\n",
       "      <td>「科幻·时空穿梭」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>俊秀才</td>\n",
       "      <td>821.62</td>\n",
       "      <td>美梦时代</td>\n",
       "      <td>2016-08-16</td>\n",
       "      <td>新书《重生之最强人生》已上传，请诸兄多多指教！</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>上帝不在天堂</td>\n",
       "      <td>809.6</td>\n",
       "      <td>埃提亚</td>\n",
       "      <td>2015-07-09</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>南希北庆</td>\n",
       "      <td>802.12</td>\n",
       "      <td>唐朝小闲人</td>\n",
       "      <td>2018-09-03</td>\n",
       "      <td>新书已发：原始大厨王！</td>\n",
       "      <td>「历史·两晋隋唐」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>博耀</td>\n",
       "      <td>788.33</td>\n",
       "      <td>九炼归仙</td>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>《九炼归仙》完本感言</td>\n",
       "      <td>「仙侠·修真文明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>七七家d猫猫</td>\n",
       "      <td>777.21</td>\n",
       "      <td>大艺术家</td>\n",
       "      <td>2013-11-15</td>\n",
       "      <td>新书上传</td>\n",
       "      <td>「都市·娱乐明星」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>名窑</td>\n",
       "      <td>776.88</td>\n",
       "      <td>极品小农场</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>新书《悠闲乡村直播间》已上架求首订</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>扎姆卡特</td>\n",
       "      <td>776.79</td>\n",
       "      <td>满愿石</td>\n",
       "      <td>2016-12-13</td>\n",
       "      <td>第五章坍塌（节五）</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>默闻勋勋</td>\n",
       "      <td>767.04</td>\n",
       "      <td>真仙奇缘</td>\n",
       "      <td>2014-03-27</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>马一角</td>\n",
       "      <td>761.67</td>\n",
       "      <td>仙欲逍遥</td>\n",
       "      <td>2014-07-23</td>\n",
       "      <td>诚心道歉，望各位书友原谅。</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>忘语</td>\n",
       "      <td>744.75</td>\n",
       "      <td>凡人修仙传</td>\n",
       "      <td>2016-01-05</td>\n",
       "      <td>忘语新书《玄界之门》</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>六道沉沦</td>\n",
       "      <td>734.22</td>\n",
       "      <td>剑道独神</td>\n",
       "      <td>2016-01-19</td>\n",
       "      <td>新群号</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>南希北庆</td>\n",
       "      <td>718.66</td>\n",
       "      <td>北宋小厨师</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>开新书啦！开新书啦！</td>\n",
       "      <td>「历史·两宋元明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>如水意</td>\n",
       "      <td>714.91</td>\n",
       "      <td>佣兵的战争</td>\n",
       "      <td>2017-09-26</td>\n",
       "      <td>9.18号新书发布，敬请关注。</td>\n",
       "      <td>「军事·战争幻想」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>鹅是老五</td>\n",
       "      <td>704.19</td>\n",
       "      <td>最强弃少</td>\n",
       "      <td>2015-11-30</td>\n",
       "      <td>新书《天下第九》</td>\n",
       "      <td>「仙侠·现代修真」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>跃千愁</td>\n",
       "      <td>698.27</td>\n",
       "      <td>飞天</td>\n",
       "      <td>2017-02-28</td>\n",
       "      <td>新书《道君》正式发布</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>指云笑天道1</td>\n",
       "      <td>692.96</td>\n",
       "      <td>隋末阴雄</td>\n",
       "      <td>2017-08-09</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「历史·两晋隋唐」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>少穿的内裤</td>\n",
       "      <td>692.14</td>\n",
       "      <td>风花醉</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>第1405章大结局</td>\n",
       "      <td>「历史·两宋元明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>左耳思念</td>\n",
       "      <td>691.15</td>\n",
       "      <td>都市之最强纨绔</td>\n",
       "      <td>2016-08-04</td>\n",
       "      <td>最后再说几句</td>\n",
       "      <td>「都市·异术超能」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>血红</td>\n",
       "      <td>687.77</td>\n",
       "      <td>光明纪元</td>\n",
       "      <td>2014-01-16</td>\n",
       "      <td>完本感言！</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>颓废龙</td>\n",
       "      <td>685.81</td>\n",
       "      <td>重生之恶魔猎人</td>\n",
       "      <td>2015-01-05</td>\n",
       "      <td>终章：烟花灿烂</td>\n",
       "      <td>「游戏·游戏异界」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>呓语痴人</td>\n",
       "      <td>677.94</td>\n",
       "      <td>韩娱之天王</td>\n",
       "      <td>2014-06-27</td>\n",
       "      <td>新书已发，求支持</td>\n",
       "      <td>「都市·娱乐明星」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>贱宗首席弟子</td>\n",
       "      <td>674.68</td>\n",
       "      <td>大魏宫廷</td>\n",
       "      <td>2018-08-06</td>\n",
       "      <td>关于新书</td>\n",
       "      <td>「历史·架空历史」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>红场唐人</td>\n",
       "      <td>674</td>\n",
       "      <td>燃烧的莫斯科</td>\n",
       "      <td>2017-08-09</td>\n",
       "      <td>第一千七百二十二章最后的胜利（大结局）</td>\n",
       "      <td>「历史·外国历史」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>暴兵对A</td>\n",
       "      <td>671.53</td>\n",
       "      <td>随身带着星际争霸</td>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>请把推荐票投给《大支配者》，另重述下本书结局的事。</td>\n",
       "      <td>「科幻·未来世界」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>老鹰吃小鸡</td>\n",
       "      <td>670.76</td>\n",
       "      <td>重生之财源滚滚</td>\n",
       "      <td>2018-05-07</td>\n",
       "      <td>新书发布了！</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>蚕茧里的牛</td>\n",
       "      <td>669.88</td>\n",
       "      <td>武极天下</td>\n",
       "      <td>2015-09-07</td>\n",
       "      <td>蚕茧新书，《真武世界》</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>鱼人二代</td>\n",
       "      <td>668.35</td>\n",
       "      <td>很纯很暧昧</td>\n",
       "      <td>2013-05-08</td>\n",
       "      <td>第两千三百八十四章T17番外特别章（4）</td>\n",
       "      <td>「都市·异术超能」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>包租东</td>\n",
       "      <td>662.26</td>\n",
       "      <td>超级修炼系统</td>\n",
       "      <td>2018-01-08</td>\n",
       "      <td>完本了！！！</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>辰东</td>\n",
       "      <td>657.66</td>\n",
       "      <td>完美世界</td>\n",
       "      <td>2016-11-07</td>\n",
       "      <td>我的新书《圣墟》已上传</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>耳根</td>\n",
       "      <td>651.44</td>\n",
       "      <td>仙逆</td>\n",
       "      <td>2015-10-03</td>\n",
       "      <td>第十三卷 灯火阑珊第2088章蓦然回首（结局）</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>开心小帅</td>\n",
       "      <td>641.64</td>\n",
       "      <td>异世界的魔王大人</td>\n",
       "      <td>2017-05-15</td>\n",
       "      <td>后记</td>\n",
       "      <td>「科幻·时空穿梭」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>不问苍生问鬼神</td>\n",
       "      <td>641.44</td>\n",
       "      <td>大器宗</td>\n",
       "      <td>2016-11-08</td>\n",
       "      <td>新书《御灵真仙》已经上传，望周知</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>猛子</td>\n",
       "      <td>633.69</td>\n",
       "      <td>大汉帝国风云录</td>\n",
       "      <td>2008-03-28</td>\n",
       "      <td>新书公告和大汉结束语</td>\n",
       "      <td>「历史·秦汉三国」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>辰东</td>\n",
       "      <td>632.31</td>\n",
       "      <td>遮天</td>\n",
       "      <td>2013-06-30</td>\n",
       "      <td>我的新书《圣墟》已上传</td>\n",
       "      <td>「仙侠·修真文明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>横扫天涯</td>\n",
       "      <td>630.72</td>\n",
       "      <td>无尽丹田</td>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>新书《天道图书馆》已经200万字了，已肥可宰！</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>石闻</td>\n",
       "      <td>630.47</td>\n",
       "      <td>末世魔神游戏</td>\n",
       "      <td>2015-07-20</td>\n",
       "      <td>完本感言及新书</td>\n",
       "      <td>「科幻·末世危机」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>虎躯巨震</td>\n",
       "      <td>625.02</td>\n",
       "      <td>崛起美利坚</td>\n",
       "      <td>2018-07-20</td>\n",
       "      <td>第1959章来吧！大结局！</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         作者       字数      小说名称        更新时间                       最新章节  \\\n",
       "0      雷云风暴  2019.35      从零开始  2016-03-21          第23卷 第六章放飞希望（完结篇）   \n",
       "1      小段探花  1588.76      修神外传  2016-10-09          探花新书《修神外传仙界篇》已经上传   \n",
       "2        汉宝  1261.26     移动藏经阁  2018-08-02                番外，普林星系篇（2）   \n",
       "3       傅啸尘  1168.08      武神空间  2016-09-17                 完本感言！读者请进！   \n",
       "4      傲月长空  1104.23      异世傲天  2018-01-15           第1878~1882【大结局！】   \n",
       "5      卧牛真人  1040.22     修真四万年  2018-08-31                  新书预告结束和开始   \n",
       "6       天雷猪  1011.16      剑神重生  2014-06-01                       完本感言   \n",
       "7     张扬的五月   994.86   网游之倒行逆施  2018-04-30                       完本感言   \n",
       "8    velver   988.68      左道旁门  2015-12-22                         后记   \n",
       "9        幻雨    978.6      百炼成仙  2015-05-26        幻雨新书《厨道仙途》，大家请去看看哦！   \n",
       "10       韩错   916.92      恋战星梦  2015-06-01                   第二百章恋战星梦   \n",
       "11     狼牙怪兽   902.23      枪魔霸世  2014-11-30                       《后记》   \n",
       "12    我叫排云掌   898.69   武侠世界大穿越  2018-08-04                   完本感言以及新书   \n",
       "13      俊秀才   821.62      美梦时代  2016-08-16    新书《重生之最强人生》已上传，请诸兄多多指教！   \n",
       "14   上帝不在天堂    809.6       埃提亚  2015-07-09                       完本感言   \n",
       "15     南希北庆   802.12     唐朝小闲人  2018-09-03                新书已发：原始大厨王！   \n",
       "16       博耀   788.33      九炼归仙  2018-02-05                 《九炼归仙》完本感言   \n",
       "17   七七家d猫猫   777.21      大艺术家  2013-11-15                       新书上传   \n",
       "18       名窑   776.88     极品小农场  2017-12-27          新书《悠闲乡村直播间》已上架求首订   \n",
       "19     扎姆卡特   776.79       满愿石  2016-12-13                  第五章坍塌（节五）   \n",
       "20     默闻勋勋   767.04      真仙奇缘  2014-03-27                       完本感言   \n",
       "21      马一角   761.67      仙欲逍遥  2014-07-23              诚心道歉，望各位书友原谅。   \n",
       "22       忘语   744.75     凡人修仙传  2016-01-05                 忘语新书《玄界之门》   \n",
       "23     六道沉沦   734.22      剑道独神  2016-01-19                        新群号   \n",
       "24     南希北庆   718.66     北宋小厨师  2015-06-19                 开新书啦！开新书啦！   \n",
       "25      如水意   714.91     佣兵的战争  2017-09-26            9.18号新书发布，敬请关注。   \n",
       "26     鹅是老五   704.19      最强弃少  2015-11-30                   新书《天下第九》   \n",
       "27      跃千愁   698.27        飞天  2017-02-28                 新书《道君》正式发布   \n",
       "28   指云笑天道1   692.96      隋末阴雄  2017-08-09                       完本感言   \n",
       "29    少穿的内裤   692.14       风花醉  2018-05-14                  第1405章大结局   \n",
       "30     左耳思念   691.15   都市之最强纨绔  2016-08-04                     最后再说几句   \n",
       "31       血红   687.77      光明纪元  2014-01-16                      完本感言！   \n",
       "32      颓废龙   685.81   重生之恶魔猎人  2015-01-05                    终章：烟花灿烂   \n",
       "33     呓语痴人   677.94     韩娱之天王  2014-06-27                   新书已发，求支持   \n",
       "34   贱宗首席弟子   674.68      大魏宫廷  2018-08-06                       关于新书   \n",
       "35     红场唐人      674    燃烧的莫斯科  2017-08-09        第一千七百二十二章最后的胜利（大结局）   \n",
       "36     暴兵对A   671.53  随身带着星际争霸  2018-06-04  请把推荐票投给《大支配者》，另重述下本书结局的事。   \n",
       "37    老鹰吃小鸡   670.76   重生之财源滚滚  2018-05-07                     新书发布了！   \n",
       "38    蚕茧里的牛   669.88      武极天下  2015-09-07                蚕茧新书，《真武世界》   \n",
       "39     鱼人二代   668.35     很纯很暧昧  2013-05-08       第两千三百八十四章T17番外特别章（4）   \n",
       "40      包租东   662.26    超级修炼系统  2018-01-08                     完本了！！！   \n",
       "41       辰东   657.66      完美世界  2016-11-07                我的新书《圣墟》已上传   \n",
       "42       耳根   651.44        仙逆  2015-10-03    第十三卷 灯火阑珊第2088章蓦然回首（结局）   \n",
       "43     开心小帅   641.64  异世界的魔王大人  2017-05-15                         后记   \n",
       "44  不问苍生问鬼神   641.44       大器宗  2016-11-08           新书《御灵真仙》已经上传，望周知   \n",
       "45       猛子   633.69   大汉帝国风云录  2008-03-28                 新书公告和大汉结束语   \n",
       "46       辰东   632.31        遮天  2013-06-30                我的新书《圣墟》已上传   \n",
       "47     横扫天涯   630.72      无尽丹田  2016-07-01    新书《天道图书馆》已经200万字了，已肥可宰！   \n",
       "48       石闻   630.47    末世魔神游戏  2015-07-20                    完本感言及新书   \n",
       "49     虎躯巨震   625.02     崛起美利坚  2018-07-20              第1959章来吧！大结局！   \n",
       "\n",
       "           类别  \n",
       "0   「游戏·虚拟网游」  \n",
       "1   「仙侠·幻想修仙」  \n",
       "2   「玄幻·东方玄幻」  \n",
       "3   「玄幻·东方玄幻」  \n",
       "4   「玄幻·异世大陆」  \n",
       "5   「科幻·未来世界」  \n",
       "6   「玄幻·异世大陆」  \n",
       "7   「游戏·虚拟网游」  \n",
       "8   「都市·都市生活」  \n",
       "9   「仙侠·幻想修仙」  \n",
       "10  「都市·娱乐明星」  \n",
       "11  「玄幻·异世大陆」  \n",
       "12  「科幻·时空穿梭」  \n",
       "13  「都市·都市生活」  \n",
       "14  「游戏·虚拟网游」  \n",
       "15  「历史·两晋隋唐」  \n",
       "16  「仙侠·修真文明」  \n",
       "17  「都市·娱乐明星」  \n",
       "18  「都市·都市生活」  \n",
       "19  「玄幻·异世大陆」  \n",
       "20  「仙侠·幻想修仙」  \n",
       "21  「仙侠·幻想修仙」  \n",
       "22  「仙侠·幻想修仙」  \n",
       "23  「玄幻·东方玄幻」  \n",
       "24  「历史·两宋元明」  \n",
       "25  「军事·战争幻想」  \n",
       "26  「仙侠·现代修真」  \n",
       "27  「仙侠·幻想修仙」  \n",
       "28  「历史·两晋隋唐」  \n",
       "29  「历史·两宋元明」  \n",
       "30  「都市·异术超能」  \n",
       "31  「玄幻·东方玄幻」  \n",
       "32  「游戏·游戏异界」  \n",
       "33  「都市·娱乐明星」  \n",
       "34  「历史·架空历史」  \n",
       "35  「历史·外国历史」  \n",
       "36  「科幻·未来世界」  \n",
       "37  「都市·都市生活」  \n",
       "38  「玄幻·东方玄幻」  \n",
       "39  「都市·异术超能」  \n",
       "40  「玄幻·东方玄幻」  \n",
       "41  「玄幻·东方玄幻」  \n",
       "42  「仙侠·幻想修仙」  \n",
       "43  「科幻·时空穿梭」  \n",
       "44  「仙侠·幻想修仙」  \n",
       "45  「历史·秦汉三国」  \n",
       "46  「仙侠·修真文明」  \n",
       "47  「玄幻·异世大陆」  \n",
       "48  「科幻·末世危机」  \n",
       "49  「都市·都市生活」  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url = start_url + str(1)\n",
    "get_index(url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>作者</th>\n",
       "      <th>字数</th>\n",
       "      <th>小说名称</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>最新章节</th>\n",
       "      <th>类别</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>雷云风暴</td>\n",
       "      <td>2019.35</td>\n",
       "      <td>从零开始</td>\n",
       "      <td>2016-03-21</td>\n",
       "      <td>第23卷 第六章放飞希望（完结篇）</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>小段探花</td>\n",
       "      <td>1588.76</td>\n",
       "      <td>修神外传</td>\n",
       "      <td>2016-10-09</td>\n",
       "      <td>探花新书《修神外传仙界篇》已经上传</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>汉宝</td>\n",
       "      <td>1261.26</td>\n",
       "      <td>移动藏经阁</td>\n",
       "      <td>2018-08-02</td>\n",
       "      <td>番外，普林星系篇（2）</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>傅啸尘</td>\n",
       "      <td>1168.08</td>\n",
       "      <td>武神空间</td>\n",
       "      <td>2016-09-17</td>\n",
       "      <td>完本感言！读者请进！</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>傲月长空</td>\n",
       "      <td>1104.23</td>\n",
       "      <td>异世傲天</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>第1878~1882【大结局！】</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>卧牛真人</td>\n",
       "      <td>1040.22</td>\n",
       "      <td>修真四万年</td>\n",
       "      <td>2018-08-31</td>\n",
       "      <td>新书预告结束和开始</td>\n",
       "      <td>「科幻·未来世界」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>天雷猪</td>\n",
       "      <td>1011.16</td>\n",
       "      <td>剑神重生</td>\n",
       "      <td>2014-06-01</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>张扬的五月</td>\n",
       "      <td>994.86</td>\n",
       "      <td>网游之倒行逆施</td>\n",
       "      <td>2018-04-30</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>velver</td>\n",
       "      <td>988.68</td>\n",
       "      <td>左道旁门</td>\n",
       "      <td>2015-12-22</td>\n",
       "      <td>后记</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>幻雨</td>\n",
       "      <td>978.6</td>\n",
       "      <td>百炼成仙</td>\n",
       "      <td>2015-05-26</td>\n",
       "      <td>幻雨新书《厨道仙途》，大家请去看看哦！</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>韩错</td>\n",
       "      <td>916.92</td>\n",
       "      <td>恋战星梦</td>\n",
       "      <td>2015-06-01</td>\n",
       "      <td>第二百章恋战星梦</td>\n",
       "      <td>「都市·娱乐明星」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>狼牙怪兽</td>\n",
       "      <td>902.23</td>\n",
       "      <td>枪魔霸世</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>《后记》</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>我叫排云掌</td>\n",
       "      <td>898.69</td>\n",
       "      <td>武侠世界大穿越</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>完本感言以及新书</td>\n",
       "      <td>「科幻·时空穿梭」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>俊秀才</td>\n",
       "      <td>821.62</td>\n",
       "      <td>美梦时代</td>\n",
       "      <td>2016-08-16</td>\n",
       "      <td>新书《重生之最强人生》已上传，请诸兄多多指教！</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>上帝不在天堂</td>\n",
       "      <td>809.6</td>\n",
       "      <td>埃提亚</td>\n",
       "      <td>2015-07-09</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「游戏·虚拟网游」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>南希北庆</td>\n",
       "      <td>802.12</td>\n",
       "      <td>唐朝小闲人</td>\n",
       "      <td>2018-09-03</td>\n",
       "      <td>新书已发：原始大厨王！</td>\n",
       "      <td>「历史·两晋隋唐」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>博耀</td>\n",
       "      <td>788.33</td>\n",
       "      <td>九炼归仙</td>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>《九炼归仙》完本感言</td>\n",
       "      <td>「仙侠·修真文明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>七七家d猫猫</td>\n",
       "      <td>777.21</td>\n",
       "      <td>大艺术家</td>\n",
       "      <td>2013-11-15</td>\n",
       "      <td>新书上传</td>\n",
       "      <td>「都市·娱乐明星」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>名窑</td>\n",
       "      <td>776.88</td>\n",
       "      <td>极品小农场</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>新书《悠闲乡村直播间》已上架求首订</td>\n",
       "      <td>「都市·都市生活」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>扎姆卡特</td>\n",
       "      <td>776.79</td>\n",
       "      <td>满愿石</td>\n",
       "      <td>2016-12-13</td>\n",
       "      <td>第五章坍塌（节五）</td>\n",
       "      <td>「玄幻·异世大陆」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>默闻勋勋</td>\n",
       "      <td>767.04</td>\n",
       "      <td>真仙奇缘</td>\n",
       "      <td>2014-03-27</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>马一角</td>\n",
       "      <td>761.67</td>\n",
       "      <td>仙欲逍遥</td>\n",
       "      <td>2014-07-23</td>\n",
       "      <td>诚心道歉，望各位书友原谅。</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>忘语</td>\n",
       "      <td>744.75</td>\n",
       "      <td>凡人修仙传</td>\n",
       "      <td>2016-01-05</td>\n",
       "      <td>忘语新书《玄界之门》</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>六道沉沦</td>\n",
       "      <td>734.22</td>\n",
       "      <td>剑道独神</td>\n",
       "      <td>2016-01-19</td>\n",
       "      <td>新群号</td>\n",
       "      <td>「玄幻·东方玄幻」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>南希北庆</td>\n",
       "      <td>718.66</td>\n",
       "      <td>北宋小厨师</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>开新书啦！开新书啦！</td>\n",
       "      <td>「历史·两宋元明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>如水意</td>\n",
       "      <td>714.91</td>\n",
       "      <td>佣兵的战争</td>\n",
       "      <td>2017-09-26</td>\n",
       "      <td>9.18号新书发布，敬请关注。</td>\n",
       "      <td>「军事·战争幻想」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>鹅是老五</td>\n",
       "      <td>704.19</td>\n",
       "      <td>最强弃少</td>\n",
       "      <td>2015-11-30</td>\n",
       "      <td>新书《天下第九》</td>\n",
       "      <td>「仙侠·现代修真」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>跃千愁</td>\n",
       "      <td>698.27</td>\n",
       "      <td>飞天</td>\n",
       "      <td>2017-02-28</td>\n",
       "      <td>新书《道君》正式发布</td>\n",
       "      <td>「仙侠·幻想修仙」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>指云笑天道1</td>\n",
       "      <td>692.96</td>\n",
       "      <td>隋末阴雄</td>\n",
       "      <td>2017-08-09</td>\n",
       "      <td>完本感言</td>\n",
       "      <td>「历史·两晋隋唐」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>少穿的内裤</td>\n",
       "      <td>692.14</td>\n",
       "      <td>风花醉</td>\n",
       "      <td>2018-05-14</td>\n",
       "      <td>第1405章大结局</td>\n",
       "      <td>「历史·两宋元明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>小段探花</td>\n",
       "      <td>13.64</td>\n",
       "      <td>月无涯</td>\n",
       "      <td>2011-07-25</td>\n",
       "      <td>第五十五章大结局</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>杨亦歌</td>\n",
       "      <td>13.63</td>\n",
       "      <td>浮生散记</td>\n",
       "      <td>2017-07-17</td>\n",
       "      <td>魂兮</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>晓起</td>\n",
       "      <td>13.49</td>\n",
       "      <td>军民鱼水情</td>\n",
       "      <td>2010-12-17</td>\n",
       "      <td>第二十五章凯旋</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>骆青</td>\n",
       "      <td>13.49</td>\n",
       "      <td>六指新娘</td>\n",
       "      <td>2014-05-06</td>\n",
       "      <td>第二十五章往事如烟（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>满江红11</td>\n",
       "      <td>13.49</td>\n",
       "      <td>涅磐重生之殇</td>\n",
       "      <td>2010-05-21</td>\n",
       "      <td>第五十七章出乎意外</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>索斯</td>\n",
       "      <td>13.3</td>\n",
       "      <td>法师故事2</td>\n",
       "      <td>2015-09-22</td>\n",
       "      <td>大结局</td>\n",
       "      <td>「奇幻·剑与魔法」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>沸腾的茶水</td>\n",
       "      <td>13.25</td>\n",
       "      <td>碧血王朝</td>\n",
       "      <td>2007-04-28</td>\n",
       "      <td>第一百四十四章沉寂</td>\n",
       "      <td>「玄幻·王朝争霸」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Alex.Zhang</td>\n",
       "      <td>13.04</td>\n",
       "      <td>云游仙境</td>\n",
       "      <td>2005-01-27</td>\n",
       "      <td>卷四尾章终曲</td>\n",
       "      <td>「仙侠·修真文明」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>吴家南</td>\n",
       "      <td>13.02</td>\n",
       "      <td>臭豆腐</td>\n",
       "      <td>2010-09-28</td>\n",
       "      <td>三十六</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>刘凯丰—幸福美好</td>\n",
       "      <td>12.92</td>\n",
       "      <td>扎龙生死情</td>\n",
       "      <td>2010-08-24</td>\n",
       "      <td>第三十集游览鹤城风景美隔世相见驾鹤飞</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>尸身人面</td>\n",
       "      <td>12.9</td>\n",
       "      <td>罪愆</td>\n",
       "      <td>2011-05-20</td>\n",
       "      <td>第五十五章大结局</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>孟璐娟</td>\n",
       "      <td>12.85</td>\n",
       "      <td>华都之恋</td>\n",
       "      <td>2018-04-24</td>\n",
       "      <td>第四十章结局</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>韦迪</td>\n",
       "      <td>12.79</td>\n",
       "      <td>没有诗意的人生</td>\n",
       "      <td>2010-07-13</td>\n",
       "      <td>第58章新的生活</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>依然饭稀特</td>\n",
       "      <td>12.65</td>\n",
       "      <td>拣到我的日本老婆</td>\n",
       "      <td>2010-09-01</td>\n",
       "      <td>尾声终点站（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>藏原</td>\n",
       "      <td>12.63</td>\n",
       "      <td>青藏高原杂记</td>\n",
       "      <td>2011-05-20</td>\n",
       "      <td>结束语</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>小亭已晚0</td>\n",
       "      <td>12.37</td>\n",
       "      <td>假如我变成回忆</td>\n",
       "      <td>2014-09-16</td>\n",
       "      <td>第一百二十二章生离死别</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>江小笛</td>\n",
       "      <td>12.13</td>\n",
       "      <td>单身不是罪过</td>\n",
       "      <td>2010-03-16</td>\n",
       "      <td>第二十章苏格拉底与柏拉图</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>崔小雅</td>\n",
       "      <td>12.04</td>\n",
       "      <td>爱情六公里</td>\n",
       "      <td>2011-08-03</td>\n",
       "      <td>41、你不知道（完结篇）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>牟芷</td>\n",
       "      <td>11.92</td>\n",
       "      <td>爱就好好爱</td>\n",
       "      <td>2010-04-29</td>\n",
       "      <td>第十六章是结局不是结束（4）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>王小邪A</td>\n",
       "      <td>11.86</td>\n",
       "      <td>宅男之神</td>\n",
       "      <td>2010-09-10</td>\n",
       "      <td>第19章魔幻青春（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>康夏凯</td>\n",
       "      <td>11.81</td>\n",
       "      <td>给不起的你要的爱</td>\n",
       "      <td>2010-11-24</td>\n",
       "      <td>第五十三章尾声</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>依然饭稀特</td>\n",
       "      <td>11.75</td>\n",
       "      <td>攀龙戏凤</td>\n",
       "      <td>2010-08-25</td>\n",
       "      <td>第044章血染，夕阳红（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>蓝泽</td>\n",
       "      <td>11.58</td>\n",
       "      <td>纨绔千金酷总裁</td>\n",
       "      <td>2013-09-20</td>\n",
       "      <td>五十五，三个人的分手（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>菩因因</td>\n",
       "      <td>11.54</td>\n",
       "      <td>微愿</td>\n",
       "      <td>2011-03-07</td>\n",
       "      <td>chapter05守望幸福6、最终曲（完结）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>小面包</td>\n",
       "      <td>11.5</td>\n",
       "      <td>如何前事不思量</td>\n",
       "      <td>2012-03-15</td>\n",
       "      <td>三十八</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>幽兰飘香</td>\n",
       "      <td>11.18</td>\n",
       "      <td>母爱无悔</td>\n",
       "      <td>2010-07-03</td>\n",
       "      <td>第五章母爱无悔</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>丁东歌</td>\n",
       "      <td>10.96</td>\n",
       "      <td>接头</td>\n",
       "      <td>2010-12-29</td>\n",
       "      <td>第三十三章接头</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>东道士</td>\n",
       "      <td>10.82</td>\n",
       "      <td>斗阵洪荒</td>\n",
       "      <td>2010-09-01</td>\n",
       "      <td>第五十章炎黄定天，八卦立碑【大结局】</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>易子龙</td>\n",
       "      <td>10.7</td>\n",
       "      <td>追与赶</td>\n",
       "      <td>2010-07-13</td>\n",
       "      <td>第二十四话非走不可</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>酌古</td>\n",
       "      <td>10.68</td>\n",
       "      <td>对面男生之阿土哥</td>\n",
       "      <td>2011-06-02</td>\n",
       "      <td>第三十六章执着（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9800 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            作者       字数      小说名称        更新时间                     最新章节  \\\n",
       "0         雷云风暴  2019.35      从零开始  2016-03-21        第23卷 第六章放飞希望（完结篇）   \n",
       "1         小段探花  1588.76      修神外传  2016-10-09        探花新书《修神外传仙界篇》已经上传   \n",
       "2           汉宝  1261.26     移动藏经阁  2018-08-02              番外，普林星系篇（2）   \n",
       "3          傅啸尘  1168.08      武神空间  2016-09-17               完本感言！读者请进！   \n",
       "4         傲月长空  1104.23      异世傲天  2018-01-15         第1878~1882【大结局！】   \n",
       "5         卧牛真人  1040.22     修真四万年  2018-08-31                新书预告结束和开始   \n",
       "6          天雷猪  1011.16      剑神重生  2014-06-01                     完本感言   \n",
       "7        张扬的五月   994.86   网游之倒行逆施  2018-04-30                     完本感言   \n",
       "8       velver   988.68      左道旁门  2015-12-22                       后记   \n",
       "9           幻雨    978.6      百炼成仙  2015-05-26      幻雨新书《厨道仙途》，大家请去看看哦！   \n",
       "10          韩错   916.92      恋战星梦  2015-06-01                 第二百章恋战星梦   \n",
       "11        狼牙怪兽   902.23      枪魔霸世  2014-11-30                     《后记》   \n",
       "12       我叫排云掌   898.69   武侠世界大穿越  2018-08-04                 完本感言以及新书   \n",
       "13         俊秀才   821.62      美梦时代  2016-08-16  新书《重生之最强人生》已上传，请诸兄多多指教！   \n",
       "14      上帝不在天堂    809.6       埃提亚  2015-07-09                     完本感言   \n",
       "15        南希北庆   802.12     唐朝小闲人  2018-09-03              新书已发：原始大厨王！   \n",
       "16          博耀   788.33      九炼归仙  2018-02-05               《九炼归仙》完本感言   \n",
       "17      七七家d猫猫   777.21      大艺术家  2013-11-15                     新书上传   \n",
       "18          名窑   776.88     极品小农场  2017-12-27        新书《悠闲乡村直播间》已上架求首订   \n",
       "19        扎姆卡特   776.79       满愿石  2016-12-13                第五章坍塌（节五）   \n",
       "20        默闻勋勋   767.04      真仙奇缘  2014-03-27                     完本感言   \n",
       "21         马一角   761.67      仙欲逍遥  2014-07-23            诚心道歉，望各位书友原谅。   \n",
       "22          忘语   744.75     凡人修仙传  2016-01-05               忘语新书《玄界之门》   \n",
       "23        六道沉沦   734.22      剑道独神  2016-01-19                      新群号   \n",
       "24        南希北庆   718.66     北宋小厨师  2015-06-19               开新书啦！开新书啦！   \n",
       "25         如水意   714.91     佣兵的战争  2017-09-26          9.18号新书发布，敬请关注。   \n",
       "26        鹅是老五   704.19      最强弃少  2015-11-30                 新书《天下第九》   \n",
       "27         跃千愁   698.27        飞天  2017-02-28               新书《道君》正式发布   \n",
       "28      指云笑天道1   692.96      隋末阴雄  2017-08-09                     完本感言   \n",
       "29       少穿的内裤   692.14       风花醉  2018-05-14                第1405章大结局   \n",
       "..         ...      ...       ...         ...                      ...   \n",
       "20        小段探花    13.64       月无涯  2011-07-25                 第五十五章大结局   \n",
       "21         杨亦歌    13.63      浮生散记  2017-07-17                       魂兮   \n",
       "22          晓起    13.49     军民鱼水情  2010-12-17                  第二十五章凯旋   \n",
       "23          骆青    13.49      六指新娘  2014-05-06           第二十五章往事如烟（大结局）   \n",
       "24       满江红11    13.49    涅磐重生之殇  2010-05-21                第五十七章出乎意外   \n",
       "25          索斯     13.3     法师故事2  2015-09-22                      大结局   \n",
       "26       沸腾的茶水    13.25      碧血王朝  2007-04-28                第一百四十四章沉寂   \n",
       "27  Alex.Zhang    13.04      云游仙境  2005-01-27                   卷四尾章终曲   \n",
       "28         吴家南    13.02       臭豆腐  2010-09-28                      三十六   \n",
       "29    刘凯丰—幸福美好    12.92     扎龙生死情  2010-08-24       第三十集游览鹤城风景美隔世相见驾鹤飞   \n",
       "30        尸身人面     12.9        罪愆  2011-05-20                 第五十五章大结局   \n",
       "31         孟璐娟    12.85      华都之恋  2018-04-24                   第四十章结局   \n",
       "32          韦迪    12.79   没有诗意的人生  2010-07-13                 第58章新的生活   \n",
       "33       依然饭稀特    12.65  拣到我的日本老婆  2010-09-01               尾声终点站（大结局）   \n",
       "34          藏原    12.63    青藏高原杂记  2011-05-20                      结束语   \n",
       "35       小亭已晚0    12.37   假如我变成回忆  2014-09-16              第一百二十二章生离死别   \n",
       "36         江小笛    12.13    单身不是罪过  2010-03-16             第二十章苏格拉底与柏拉图   \n",
       "37         崔小雅    12.04     爱情六公里  2011-08-03             41、你不知道（完结篇）   \n",
       "38          牟芷    11.92     爱就好好爱  2010-04-29           第十六章是结局不是结束（4）   \n",
       "39        王小邪A    11.86      宅男之神  2010-09-10            第19章魔幻青春（大结局）   \n",
       "40         康夏凯    11.81  给不起的你要的爱  2010-11-24                  第五十三章尾声   \n",
       "41       依然饭稀特    11.75      攀龙戏凤  2010-08-25         第044章血染，夕阳红（大结局）   \n",
       "42          蓝泽    11.58   纨绔千金酷总裁  2013-09-20          五十五，三个人的分手（大结局）   \n",
       "43         菩因因    11.54        微愿  2011-03-07   chapter05守望幸福6、最终曲（完结）   \n",
       "44         小面包     11.5   如何前事不思量  2012-03-15                      三十八   \n",
       "45        幽兰飘香    11.18      母爱无悔  2010-07-03                  第五章母爱无悔   \n",
       "46         丁东歌    10.96        接头  2010-12-29                  第三十三章接头   \n",
       "47         东道士    10.82      斗阵洪荒  2010-09-01       第五十章炎黄定天，八卦立碑【大结局】   \n",
       "48         易子龙     10.7       追与赶  2010-07-13                第二十四话非走不可   \n",
       "49          酌古    10.68  对面男生之阿土哥  2011-06-02             第三十六章执着（大结局）   \n",
       "\n",
       "           类别  \n",
       "0   「游戏·虚拟网游」  \n",
       "1   「仙侠·幻想修仙」  \n",
       "2   「玄幻·东方玄幻」  \n",
       "3   「玄幻·东方玄幻」  \n",
       "4   「玄幻·异世大陆」  \n",
       "5   「科幻·未来世界」  \n",
       "6   「玄幻·异世大陆」  \n",
       "7   「游戏·虚拟网游」  \n",
       "8   「都市·都市生活」  \n",
       "9   「仙侠·幻想修仙」  \n",
       "10  「都市·娱乐明星」  \n",
       "11  「玄幻·异世大陆」  \n",
       "12  「科幻·时空穿梭」  \n",
       "13  「都市·都市生活」  \n",
       "14  「游戏·虚拟网游」  \n",
       "15  「历史·两晋隋唐」  \n",
       "16  「仙侠·修真文明」  \n",
       "17  「都市·娱乐明星」  \n",
       "18  「都市·都市生活」  \n",
       "19  「玄幻·异世大陆」  \n",
       "20  「仙侠·幻想修仙」  \n",
       "21  「仙侠·幻想修仙」  \n",
       "22  「仙侠·幻想修仙」  \n",
       "23  「玄幻·东方玄幻」  \n",
       "24  「历史·两宋元明」  \n",
       "25  「军事·战争幻想」  \n",
       "26  「仙侠·现代修真」  \n",
       "27  「仙侠·幻想修仙」  \n",
       "28  「历史·两晋隋唐」  \n",
       "29  「历史·两宋元明」  \n",
       "..        ...  \n",
       "20  「短篇·短篇小说」  \n",
       "21  「短篇·短篇小说」  \n",
       "22  「短篇·短篇小说」  \n",
       "23  「短篇·短篇小说」  \n",
       "24  「短篇·短篇小说」  \n",
       "25  「奇幻·剑与魔法」  \n",
       "26  「玄幻·王朝争霸」  \n",
       "27  「仙侠·修真文明」  \n",
       "28  「短篇·短篇小说」  \n",
       "29  「短篇·短篇小说」  \n",
       "30  「短篇·短篇小说」  \n",
       "31  「短篇·短篇小说」  \n",
       "32  「短篇·短篇小说」  \n",
       "33  「短篇·短篇小说」  \n",
       "34  「短篇·短篇小说」  \n",
       "35  「短篇·短篇小说」  \n",
       "36  「短篇·短篇小说」  \n",
       "37  「短篇·短篇小说」  \n",
       "38  「短篇·短篇小说」  \n",
       "39  「短篇·短篇小说」  \n",
       "40  「短篇·短篇小说」  \n",
       "41  「短篇·短篇小说」  \n",
       "42  「短篇·短篇小说」  \n",
       "43  「短篇·短篇小说」  \n",
       "44  「短篇·短篇小说」  \n",
       "45  「短篇·短篇小说」  \n",
       "46  「短篇·短篇小说」  \n",
       "47  「短篇·短篇小说」  \n",
       "48  「短篇·短篇小说」  \n",
       "49  「短篇·短篇小说」  \n",
       "\n",
       "[9800 rows x 6 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>作者</th>\n",
       "      <th>字数</th>\n",
       "      <th>小说名称</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>最新章节</th>\n",
       "      <th>类别</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>幽兰飘香</td>\n",
       "      <td>11.18</td>\n",
       "      <td>母爱无悔</td>\n",
       "      <td>2010-07-03</td>\n",
       "      <td>第五章母爱无悔</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>丁东歌</td>\n",
       "      <td>10.96</td>\n",
       "      <td>接头</td>\n",
       "      <td>2010-12-29</td>\n",
       "      <td>第三十三章接头</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>东道士</td>\n",
       "      <td>10.82</td>\n",
       "      <td>斗阵洪荒</td>\n",
       "      <td>2010-09-01</td>\n",
       "      <td>第五十章炎黄定天，八卦立碑【大结局】</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>易子龙</td>\n",
       "      <td>10.7</td>\n",
       "      <td>追与赶</td>\n",
       "      <td>2010-07-13</td>\n",
       "      <td>第二十四话非走不可</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>酌古</td>\n",
       "      <td>10.68</td>\n",
       "      <td>对面男生之阿土哥</td>\n",
       "      <td>2011-06-02</td>\n",
       "      <td>第三十六章执着（大结局）</td>\n",
       "      <td>「短篇·短篇小说」</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      作者     字数      小说名称        更新时间                最新章节         类别\n",
       "45  幽兰飘香  11.18      母爱无悔  2010-07-03             第五章母爱无悔  「短篇·短篇小说」\n",
       "46   丁东歌  10.96        接头  2010-12-29             第三十三章接头  「短篇·短篇小说」\n",
       "47   东道士  10.82      斗阵洪荒  2010-09-01  第五十章炎黄定天，八卦立碑【大结局】  「短篇·短篇小说」\n",
       "48   易子龙   10.7       追与赶  2010-07-13           第二十四话非走不可  「短篇·短篇小说」\n",
       "49    酌古  10.68  对面男生之阿土哥  2011-06-02        第三十六章执着（大结局）  「短篇·短篇小说」"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3.to_csv(\"out.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
